Huge planning time == PostgreSQL 17.7 (Ubuntu 17.7-1.1C) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04.2) 11.4.0, 64-bit OS - UBUNTU VERSION="22.04.2 LTS (Jammy Jellyfish)" \d _InfoRg8199 Таблица "public._inforg8199" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию ----------------+--------------+--------------------+-------------------+-------------- _fld8200_type | bytea | | not null | _fld8200_rtref | bytea | | not null | _fld8200_rrref | bytea | | not null | _fld8201rref | bytea | | not null | _fld8202rref | bytea | | not null | _fld8203 | numeric(1,0) | | not null | _fld8204_type | bytea | | not null | _fld8204_rtref | bytea | | not null | _fld8204_rrref | bytea | | not null | _fld809 | numeric(7,0) | | not null | _fld7827 | bytea | | not null | Индексы: "_inforg8199_1" UNIQUE, btree (_fld809, _fld8200_type, _fld8200_rtref, _fld8200_rrref, _fld8201rref, _fld8202rref, _fld8203) CLUSTER "_inforg8199_2" UNIQUE, btree (_fld809, _fld8201rref, _fld8200_type, _fld8200_rtref, _fld8200_rrref, _fld8202rref, _fld8203) "_inforg8199_3" UNIQUE, btree (_fld809, _fld8202rref, _fld8200_type, _fld8200_rtref, _fld8200_rrref, _fld8201rref, _fld8203) "_inforg8199_4" UNIQUE, btree (_fld809, _fld8204_type, _fld8204_rtref, _fld8204_rrref, _fld8200_type, _fld8200_rtref, _fld8200_rrref, _fld8201rref, _fld8202rref, _fld8203) relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size -------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _inforg8199 | 298 | 13993 | 0 | r | 11 | f | {autovacuum_enabled=true} | 2449408 \d _InfoRg10621 Таблица "public._inforg10621" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию -----------------+--------------+--------------------+-------------------+-------------- _fld10622rref | bytea | | not null | _fld15131rref | bytea | | not null | _fld10623rref | bytea | | not null | _fld10624_type | bytea | | not null | _fld10624_rtref | bytea | | not null | _fld10624_rrref | bytea | | not null | _fld10625 | boolean | | not null | _fld10626 | boolean | | not null | _fld10627 | boolean | | not null | _fld10628 | boolean | | not null | _fld10629 | boolean | | not null | _fld7826 | bytea | | not null | _fld809 | numeric(7,0) | | not null | _fld7827 | bytea | | not null | Индексы: "_inforg10621_1" UNIQUE, btree (_fld809, _fld10622rref, _fld15131rref, _fld10623rref, _fld10624_type, _fld10624_rtref, _fld10624_rrref) CLUSTER "_inforg10621_2" UNIQUE, btree (_fld809, _fld15131rref, _fld10622rref, _fld10623rref, _fld10624_type, _fld10624_rtref, _fld10624_rrref) "_inforg10621_3" UNIQUE, btree (_fld809, _fld10623rref, _fld10622rref, _fld15131rref, _fld10624_type, _fld10624_rtref, _fld10624_rrref) "_inforg10621_4" UNIQUE, btree (_fld809, _fld10624_type, _fld10624_rtref, _fld10624_rrref, _fld10622rref, _fld15131rref, _fld10623rref) relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size --------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _inforg10621 | 1099 | 57135 | 0 | r | 14 | f | {autovacuum_enabled=true} | 9011200 \d _Reference127 _fld1818rref | bytea | | not null | _fld1819 | mvarchar(40) | | not null | _fld1820rref | bytea | | not null | _fld1821 | mvarchar | | not null | _fld1822_type | bytea | | not null | _fld1822_rtref | bytea | | not null | _fld1822_rrref | bytea | | not null | _fld1823 | timestamp without time zone | | not null | _fld1824 | numeric(15,2) | | not null | _fld1825 | numeric(15,2) | | not null | _fld1826 | mvarchar | | not null | _fld1827 | mvarchar | | not null | _fld1828rref | bytea | | not null | _fld1829 | boolean | | not null | _fld1830_type | bytea | | not null | _fld1830_rtref | bytea | | not null | _fld1830_rrref | bytea | | not null | _fld1831_type | bytea | | not null | _fld1831_rtref | bytea | | not null | _fld1831_rrref | bytea | | not null | _fld1832rref | bytea | | not null | _fld1833 | numeric(10,0) | | not null | _fld1834rref | bytea | | not null | _fld1269rref | bytea | | not null | _fld809 | numeric(7,0) | | not null | _fld1459 | bytea | | not null | Индексы: "_reference127_1" btree (_fld809, _predefinedid) "_reference127_10" UNIQUE, btree (_fld809, _fld1809rref, _idrref) "_reference127_11" UNIQUE, btree (_fld809, _fld1818rref, _idrref) "_reference127_12" UNIQUE, btree (_fld809, _fld1819, _idrref) "_reference127_13" UNIQUE, btree (_fld809, _fld1828rref, _idrref) "_reference127_14" UNIQUE, btree (_fld809, _fld1459, _idrref) "_reference127_2" UNIQUE, btree (_fld809, _code, _idrref) "_reference127_3" UNIQUE, btree (_fld809, _description, _idrref) "_reference127_4" UNIQUE, btree (_fld809, _fld1780rref, _idrref) "_reference127_5" UNIQUE, btree (_fld809, _fld1781rref, _idrref) "_reference127_6" UNIQUE, btree (_fld809, _fld1782, _idrref) "_reference127_7" UNIQUE, btree (_fld809, _fld1787, _idrref) "_reference127_8" UNIQUE, btree (_fld809, _fld1790rref, _idrref) "_reference127_9" UNIQUE, btree (_fld809, _fld1791, _idrref) "_reference127_s_hpk" UNIQUE, btree (_fld809, _idrref) CLUSTER relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size ---------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _reference127 | 128 | 759 | 0 | r | 89 | f | {autovacuum_enabled=true} | 1056768 \d _InfoRg12030 Таблица "public._inforg12030" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию ---------------+---------------+--------------------+-------------------+-------------- _fld12031rref | bytea | | not null | _fld12032rref | bytea | | not null | _fld12033 | numeric(15,2) | | not null | _fld12034 | numeric(15,2) | | not null | _fld7826 | bytea | | not null | _fld809 | numeric(7,0) | | not null | _fld7827 | bytea | | not null | Индексы: "_inforg12030_1" UNIQUE, btree (_fld809, _fld12031rref, _fld12032rref) CLUSTER "_inforg12030_2" UNIQUE, btree (_fld809, _fld12032rref, _fld12031rref) relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size --------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _inforg12030 | 0 | 0 | 0 | r | 7 | f | {autovacuum_enabled=true} | 8192 \d _Reference312 _fld4789 | mvarchar(256) | | not null | _fld4790rref | bytea | | not null | _fld4791_type | bytea | | not null | _fld4791_rtref | bytea | | not null | _fld4791_rrref | bytea | | not null | _fld4792rref | bytea | | not null | _fld4793rref | bytea | | not null | _fld4794_type | bytea | | not null | _fld4794_rtref | bytea | | not null | _fld4794_rrref | bytea | | not null | _fld4795 | timestamp without time zone | | not null | _fld4796 | timestamp without time zone | | not null | _fld4797 | mvarchar(50) | | not null | _fld4798 | numeric(5,0) | | not null | _fld4799 | mvarchar | | not null | _fld4800 | numeric(10,0) | | not null | _fld4801 | mvarchar(10) | | not null | _fld4802rref | bytea | | not null | _fld4803 | bytea | | not null | _fld4804 | boolean | | not null | _fld4805rref | bytea | | not null | _fld4806 | mvarchar(255) | | not null | _fld1269rref | bytea | | not null | _fld809 | numeric(7,0) | | not null | Индексы: "_reference312_1" btree (_fld809, _predefinedid) "_reference312_10" UNIQUE, btree (_fld809, _fld4790rref, _idrref) "_reference312_11" UNIQUE, btree (_fld809, _fld4791_type, _fld4791_rtref, _fld4791_rrref, _idrref) "_reference312_12" UNIQUE, btree (_fld809, _fld4793rref, _idrref) "_reference312_13" UNIQUE, btree (_fld809, _fld4796, _idrref) "_reference312_14" UNIQUE, btree (_fld809, _fld4800, _idrref) "_reference312_15" UNIQUE, btree (_fld809, _fld4801, _idrref) "_reference312_16" UNIQUE, btree (_fld809, _fld4802rref, _idrref) "_reference312_2" UNIQUE, btree (_fld809, _code, _idrref) "_reference312_3" UNIQUE, btree (_fld809, _description, _idrref) "_reference312_4" UNIQUE, btree (_fld809, _fld4780_type, _fld4780_rtref, _fld4780_rrref, _idrref) "_reference312_5" UNIQUE, btree (_fld809, _fld4781_type, _fld4781_rtref, _fld4781_rrref, _description, _idrref, _marked) "_reference312_6" UNIQUE, btree (_fld809, _fld4783, _idrref) "_reference312_7" UNIQUE, btree (_fld809, _fld4784, _idrref) "_reference312_8" UNIQUE, btree (_fld809, _fld4788, _idrref) "_reference312_9" UNIQUE, btree (_fld809, _fld4789, _idrref) "_reference312_s_hpk" UNIQUE, btree (_fld809, _idrref) CLUSTER relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size ---------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _reference312 | 53 | 574 | 0 | r | 43 | f | {autovacuum_enabled=true} | 442368 \d _InfoRg11506 Таблица "public._inforg11506" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию -----------------+-----------------------------+--------------------+-------------------+-------------- _fld11507_type | bytea | | not null | _fld11507_rtref | bytea | | not null | _fld11507_rrref | bytea | | not null | _fld11508rref | bytea | | not null | _fld11509_type | bytea | | not null | _fld11509_rtref | bytea | | not null | _fld11509_rrref | bytea | | not null | _fld11510 | mvarchar(250) | | not null | _fld11511rref | bytea | | not null | _fld11512 | boolean | | not null | _fld11513 | timestamp without time zone | | not null | _fld11514 | mvarchar | | not null | _fld11515 | numeric(6,0) | | not null | _fld11516_type | bytea | | not null | _fld11516_rtref | bytea | | not null | _fld11516_rrref | bytea | | not null | _fld7826 | bytea | | not null | _fld3920 | mvarchar | | not null | _fld3921 | mvarchar | | not null | _fld809 | numeric(7,0) | | not null | Индексы: "_inforg11506_1" UNIQUE, btree (_fld809, _fld11507_type, _fld11507_rtref, _fld11507_rrref, _fld11508rref, _fld11509_type, _fld11509_rtref, _fld11509_rrref, _fld11510, _fld11511rref) CLUSTER "_inforg11506_2" UNIQUE, btree (_fld809, _fld11509_type, _fld11509_rtref, _fld11509_rrref, _fld11507_type, _fld11507_rtref, _fld11507_rrref, _fld11508rref, _fld11510, _fld11511rref) relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size --------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _inforg11506 | 12 | 528 | 0 | r | 20 | f | {autovacuum_enabled=true} | 106496 \d _InfoRg8926 Таблица "public._inforg8926" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию ----------------+-----------------------------+--------------------+-------------------+-------------- _fld8927_type | bytea | | not null | _fld8927_rtref | bytea | | not null | _fld8927_rrref | bytea | | not null | _fld8928rref | bytea | | not null | _fld8929_type | bytea | | not null | _fld8929_rtref | bytea | | not null | _fld8929_rrref | bytea | | not null | _fld8930 | timestamp without time zone | | not null | _fld8931 | boolean | | not null | _fld7826 | bytea | | not null | _fld809 | numeric(7,0) | | not null | _fld7827 | bytea | | not null | Индексы: "_inforg8926_1" UNIQUE, btree (_fld809, _fld8927_type, _fld8927_rtref, _fld8927_rrref, _fld8928rref) CLUSTER "_inforg8926_2" UNIQUE, btree (_fld809, _fld8928rref, _fld8927_type, _fld8927_rtref, _fld8927_rrref) "_inforg8926_3" UNIQUE, btree (_fld809, _fld8929_type, _fld8929_rtref, _fld8929_rrref, _fld8927_type, _fld8927_rtref, _fld8927_rrref, _fld8928rref) relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size -------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _inforg8926 | 0 | 0 | 0 | r | 12 | f | {autovacuum_enabled=true} | 8192 \d _Reference147 Таблица "public._reference147" Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию ----------------+-----------------------------+--------------------+-------------------+-------------- _idrref | bytea | | not null | _version | integer | | not null | 0 _marked | boolean | | not null | _predefinedid | bytea | | not null | _parentidrref | bytea | | not null | _code | mvarchar(9) | | not null | _description | mvarchar(150) | | not null | _fld2132_type | bytea | | not null | _fld2132_rtref | bytea | | not null | _fld2132_rrref | bytea | | not null | _fld2133 | timestamp without time zone | | not null | _fld2134 | mvarchar | | not null | _fld2135 | boolean | | not null | _fld809 | numeric(7,0) | | not null | Индексы: "_reference147_1" btree (_fld809, _predefinedid) "_reference147_2" UNIQUE, btree (_fld809, _parentidrref, _code, _idrref) "_reference147_3" UNIQUE, btree (_fld809, _parentidrref, _description, _idrref) "_reference147_4" UNIQUE, btree (_fld809, _code, _idrref) "_reference147_5" UNIQUE, btree (_fld809, _description, _idrref) "_reference147_6" UNIQUE, btree (_fld809, _parentidrref, _fld2135, _idrref) "_reference147_7" UNIQUE, btree (_fld809, _fld2135, _idrref) "_reference147_s_hpk" UNIQUE, btree (_fld809, _idrref) CLUSTER relname | relpages | reltuples | relallvisible | relkind | relnatts | relhassubclass | reloptions | pg_table_size ---------------+----------+-----------+---------------+---------+----------+----------------+---------------------------+--------------- _reference147 | 1 | 1 | 0 | r | 14 | f | {autovacuum_enabled=true} | 16384 cpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Address sizes: 43 bits physical, 48 bits virtual Byte Order: Little Endian CPU(s): 6 On-line CPU(s) list: 0-5 Vendor ID: GenuineIntel Model name: Intel(R) Xeon(R) Gold 5220R CPU @ 2.20GHz CPU family: 6 Model: 85 Thread(s) per core: 1 Core(s) per socket: 3 Socket(s): 2 Stepping: 7 mem total used free shared buff/cache available Mem: 24605532 513776 18305948 1987800 5785808 21694868 Swap: 8388604 0 8388604 shared_buffers 6GB effective_cache_size 16GB effective_io_concurrency 2 bonnie++ -f -n0 -x4 -d /var/lib/postgresql format_version,bonnie_version,name,concurrency,seed,file_size,io_chunk_size,putc,putc_cpu,put_block,put_block_cpu,rewrite,rewrite_cpu,getc,getc_cpu,get_block,get_block_cpu,seeks,seeks_cpu,num_files,max_size,min_size,num_dirs,file_chunk_size,seq_create,seq_create_cpu,seq_stat,seq_stat_cpu,seq_del,seq_del_cpu,ran_create,ran_create_cpu,ran_stat,ran_stat_cpu,ran_del,ran_del_cpu,putc_latency,put_block_latency,rewrite_latency,getc_latency,get_block_latency,seeks_latency,seq_create_latency,seq_stat_latency,seq_del_latency,ran_create_latency,ran_stat_latency,ran_del_latency Writing intelligently...done Rewriting...done Reading intelligently...done start 'em...done...done...done...done...done... 1.98,2.00,ta-func3-sql1-test,1,1768285869,47G,,8192,5,,,452086,44,122549,12,,,137416,8,15624,172,,,,,,,,,,,,,,,,,,,50659us,66581us,,21821us,2422us,,,,,, Writing intelligently...done Rewriting...done Reading intelligently...done start 'em...done...done...done...done...done... 1.98,2.00,ta-func3-sql1-test,1,1768285869,47G,,8192,5,,,462041,44,118181,11,,,146596,8,3790,116,,,,,,,,,,,,,,,,,,,45478us,138ms,,19240us,2089us,,,,,, Writing intelligently...done Rewriting...done Reading intelligently...done start 'em...done...done...done...done...done... 1.98,2.00,ta-func3-sql1-test,1,1768285869,47G,,8192,5,,,628882,53,135431,12,,,143343,8,3648,119,,,,,,,,,,,,,,,,,,,26509us,55469us,,23591us,1823us,,,,,, Writing intelligently...done Rewriting...done Reading intelligently...done start 'em...done...done...done...done...done... 1.98,2.00,ta-func3-sql1-test,1,1768285869,47G,,8192,5,,,1030856,83,134357,12,,,143619,8,3653,113,,,,,,,,,,,,,,,,,,,30936us,60986us,,22422us,15658us,,,,,, p